CREATE EXTERNAL TABLE jms_ods.tab_report_recycleoption
(
    SITE_CODE   string COMMENT '网点编号',
    SITE_NAME   string COMMENT '网点名称',
    CREATE_TIME timestamp COMMENT '创建时间'
) comment '循环袋流向配置表'
 PARTITIONED BY (dt STRING COMMENT '更新日期 (yyyy-MM-dd)')
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_ods.db/external/tab_report_recycleoption'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );
